ALTER TABLE `coupon_gv_customer` CHANGE `amount` `amount` DECIMAL(13,4) NOT NULL DEFAULT '0.0000';
UPDATE `gx_configurations` SET `value`='1' WHERE `key`='configuration/DEFAULT_CUSTOMERS_STATUS_ID_GUEST';
UPDATE `languages` SET
    `date_format_long` = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(`date_format_long`, '%S', 's'), '%M', 'i'), '%B', 'F'), '%A', 'l'), '%', ''),
    `date_format_short` = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(`date_format_short`, '%S', 's'), '%M', 'i'), '%B', 'F'), '%A', 'l'), '%', ''),
    `date_time_format` = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(`date_time_format`, '%S', 's'), '%M', 'i'), '%B', 'F'), '%A', 'l'), '%', '');

DELETE a.* FROM gx_lang_configurations AS a LEFT JOIN languages l ON (a.`language_id` = l.`languages_id`) WHERE l.`languages_id` IS NULL;
DELETE a.* FROM content_manager_history AS a LEFT JOIN languages l ON (a.`languages_id` = l.`languages_id`) WHERE l.`languages_id` IS NULL;
DELETE a.* FROM cookie_consent_panel_purposes AS a LEFT JOIN languages l ON (a.`language_id` = l.`languages_id`) WHERE l.`languages_id` IS NULL;
DELETE a.* FROM export_schemes AS a LEFT JOIN languages l ON (a.`languages_id` = l.`languages_id`) WHERE a.`languages_id` != 0 AND l.`languages_id` IS NULL;
DELETE a.* FROM export_types AS a LEFT JOIN languages l ON (a.`language_id` = l.`languages_id`) WHERE l.`languages_id` IS NULL;
DELETE a.* FROM google_export_availability AS a LEFT JOIN languages l ON (a.`language_id` = l.`languages_id`) WHERE l.`languages_id` IS NULL;
DELETE a.* FROM google_export_condition AS a LEFT JOIN languages l ON (a.`language_id` = l.`languages_id`) WHERE l.`languages_id` IS NULL;
DELETE a.* FROM product_image_list_image_text AS a LEFT JOIN languages l ON (a.`language_id` = l.`languages_id`) WHERE l.`languages_id` IS NULL;
DELETE a.* FROM shipping_and_payment_matrix AS a LEFT JOIN languages l ON (a.`language_id` = l.`languages_id`) WHERE l.`languages_id` IS NULL;
DELETE a.* FROM slide_images AS a LEFT JOIN languages l ON (a.`language_id` = l.`languages_id`) WHERE l.`languages_id` IS NULL;
DELETE a.* FROM slides AS a LEFT JOIN languages l ON (a.`language_id` = l.`languages_id`) WHERE l.`languages_id` IS NULL;
DELETE a.* FROM static_seo_url_contents AS a LEFT JOIN languages l ON (a.`language_id` = l.`languages_id`) WHERE l.`languages_id` IS NULL;

UPDATE `agreements` SET `language_id` = 0 WHERE `language_id` NOT IN (SELECT `languages_id` FROM languages);
UPDATE `orders_parcel_tracking_codes` SET `language_id` = 0 WHERE `language_id` NOT IN (SELECT `languages_id` FROM languages);
ALTER TABLE `customers_info` CHANGE `customers_info_id` `customers_info_id` INT(11) NOT NULL DEFAULT '0' COMMENT 'represents customers.customers_id';

UPDATE products AS `p` SET `p`.`use_properties_combis_quantity`=0 WHERE `p`.`products_id` NOT IN (SELECT DISTINCT `products_id` FROM products_properties_combis);

ALTER TABLE `shipping_status` CHANGE `shipping_status_name` `shipping_status_name` VARCHAR(255) NOT NULL DEFAULT '';
